ODAC

TSmartQueryOptions Members

TSmartQueryOptions class overview.

Properties

Name Description

AutoClose (inherited from TOraDataSetOptions)

 Used to close OCI cursor after fetching all rows.

AutoPrepare (inherited from TDADataSetOptions)

 Used to execute automatic TCustomDADataSet.Prepare on the query execution.

CacheCalcFields (inherited from TDADataSetOptions)

 Used to enable caching of the TField.Calculated and TField.Lookup fields.

CacheLobs (inherited from TOraDataSetOptions)

 Used to allocate local memory buffer to hold a copy of the Lob content.

CompressBlobMode (inherited from TDADataSetOptions)

 Used to store values of the BLOB fields in compressed form.

DefaultValues (inherited from TOraDataSetOptions)

 Used for TOraDataSet to fill the DefaultExpression property of TField objects by appropriate value.

DeferredLobRead (inherited from TOraDataSetOptions)

 Used to fetch all Oracle 8 Lob values when they are explicitly requested.

DetailDelay (inherited from TDADataSetOptions)

 Used to get or set a delay in milliseconds before refreshing detail dataset while navigating master dataset.

DynamicReadThreshold (inherited from TOraDataSetOptions)

 Used to enable dynamic data reading and reduce memory consumption during data retrieval.

EnableBCD (inherited from TOraDataSetOptions)

 Used to enable currency type. Default value of this option is False.

EnableFMTBCD (inherited from TOraDataSetOptions)

 Used to enable using FMTBCD instead of float for large integer numbers to keep precision.

ExtendedFieldsInfo (inherited from TOraDataSetOptions)

 Used to perform an additional query to get information about returned fields and the tables they belong to.

FieldsAsString (inherited from TOraDataSetOptions)

 Used to treat all non-BLOB fields as being of string datatype.

FieldsOrigin (inherited from TDADataSetOptions)

 Used for TCustomDADataSet to fill the Origin property of the TField objects by appropriate value when opening a dataset.

FlatBuffers (inherited from TDADataSetOptions)

 Used to control how a dataset treats data of the ftString and ftVarBytes fields.

FullRefresh (inherited from TOraDataSetOptions)

 Used to refresh fields of all tables by the RefreshRecord method.

HideRowId (inherited from TOraDataSetOptionsDS)

 Used to display the ROWID column.

InsertAllSetFields (inherited from TDADataSetOptions)

 Used to include all set dataset fields in the generated INSERT statement

KeepPrepared (inherited from TOraDataSetOptionsDS)

 Used to keep TOraDataSet prepared after closing.

LocalMasterDetail (inherited from TDADataSetOptions)

 Used for TCustomDADataSet to use local filtering to establish master/detail relationship for detail dataset and does not refer to the server.

LongStrings (inherited from TDADataSetOptions)

 Used to represent string fields with the length that is greater than 255 as TStringField.

MasterFieldsNullable (inherited from TDADataSetOptions)

 Allows to use NULL values in the fields by which the relation is built, when generating the query for the Detail tables (when this option is enabled, the performance can get worse).

NumberRange (inherited from TDADataSetOptions)

 Used to set the MaxValue and MinValue properties of TIntegerField and TFloatField to appropriate values.

PrefetchLobSize (inherited from TOraDataSetOptions)

 Used to retrieve the LOB length and the LOB data beginning during regular fetch.

PrefetchRows (inherited from TOraDataSetOptions)

 Used to set the number of rows to be prefetched during the execution of a query.

PrepareUpdateSQL (inherited from TOraDataSetOptions)

 Used to automatically prepare update queries before execution.

ProcNamedParams (inherited from TOraDataSetOptions)

 Used to specify a notation method of passing parameter values to the stored PL/SQL object.

QueryRecCount (inherited from TDADataSetOptions)

 Used for TCustomDADataSet to perform additional query to get the record count for this SELECT, so the RecordCount property reflects the actual number of records.

QuoteNames (inherited from TDADataSetOptions)

 Used for TCustomDADataSet to quote all database object names in autogenerated SQL statements such as update SQL.

RawAsString (inherited from TOraDataSetOptions)

 Used to treat all RAW fields as being of string datatype.

ReflectChangeNotify (inherited from TOraDataSetOptions)

 Used for a dataset component to refresh its data when it gets database change notification messages in response to DML or DDL changes on the objects associated with the dataset query.

RemoveOnRefresh (inherited from TDADataSetOptions)

 Used for a dataset to locally remove a record that can not be found on the server.

RequiredFields (inherited from TDADataSetOptions)

 Used for TCustomDADataSet to set the Required property of the TField objects for the NOT NULL fields.

ReturnParams (inherited from TDADataSetOptions)

 Used to return the new value of fields to dataset after insert or update.

ScrollableCursor (inherited from TOraDataSetOptions)

 Used for TOraDataSet to use scrollable server cursor (available since Oracle 9 only) instead of caching data on the client side.

SetFieldsReadOnly (inherited from TDADataSetOptions)

 Used for a dataset to set the ReadOnly property to True for all fields that do not belong to UpdatingTable or can not be updated.

StatementCache (inherited from TOraDataSetOptions)

 Used to get a value indicating whether Oracle resources assosiated with the current statement will be cached inside a session.

StrictUpdate (inherited from TDADataSetOptions)

 Used for TCustomDADataSet to raise an exception when the number of updated or deleted records is not equal 1.

TemporaryLobUpdate (inherited from TOraDataSetOptions)

 Temporary LOBs are used to write input and input/output LOB parameters into database when executing dataset's SQL statements.

TrimFixedChar (inherited from TDADataSetOptions)

 Specifies whether to discard all trailing spaces in the string fields of a dataset.

UpdateAllFields (inherited from TDADataSetOptions)

 Used to include all dataset fields in the generated UPDATE and INSERT statements.

UpdateBatchSize (inherited from TDADataSetOptions)

 Used to get or set a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.
© 1997-2025 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback